PV returns a Number specifying the present value of an annuity based on periodic, fixed payments to be paid in the future and a fixed interest rate.
The following example is applicable to both Basic and Crystal syntax:
Suppose that you want to buy a condo and can make payments of $1100 twice a month (24 annual payments). If the mortgage rates are 7 percent, and you want to pay off the condo in 10 years, what is the maximum loan that you can take out?
PV (0.07 / 24, 10 * 24,
Returns 189668 (rounded to the nearest dollar). Thus you can afford a loan of about $190,000. Notice that the payment argument is negative since you are paying out the money each month.
This function is designed to work like the Visual Basic function of the same name.
Seagate Software IMG Holdings, Inc. http://www.seagatesoftware.com Support services: http://support.seagatesoftware.com |